<?php
require_once("db.class.php");
$db=new DB();
$db->query("select * from user as a where a.lastname like \"%".$_POST["c1"]."\"; ");
echo "<table width=auto border=\"1\">";
echo "<tr>";
echo "<td>id_user</td><td>lastname</td><td>firstname</td><td>mail</td><td>mobile</td>" ;
		echo "<td>".$db->row['lastname']."</td>";
		echo "<td>".$db->row['firstname']."</td>";
		echo "<td>".$db->row['mail']."</td>";
	echo "</tr>";
while($db->fetch_assoc()){
echo "<tr>";
		echo "<td>".$db->row['id_user']."</td>" ;
		echo "<td>".$db->row['lastname']."</td>";
		echo "<td>".$db->row['firstname']."</td>";
		echo "<td>".$db->row['mail']."</td>";
		
echo "</tr>";
}
echo "</table>";
?>